﻿CREATE TABLE [dbo].[LoginServerRole] (
    [LoginId]      INT NOT NULL,
    [ServerRoleId] INT NOT NULL,
    CONSTRAINT [PK_LoginServerRole] PRIMARY KEY CLUSTERED ([LoginId] ASC, [ServerRoleId] ASC),
    CONSTRAINT [FK_LoginServerRole_Login] FOREIGN KEY ([LoginId]) REFERENCES [dbo].[Login] ([LoginId]),
    CONSTRAINT [FK_LoginServerRole_ServerRole] FOREIGN KEY ([ServerRoleId]) REFERENCES [dbo].[ServerRole] ([ServerRoleId])
);

